2013-07-05 - 7195.300 - Rel Notes - Rewrite BI FI reports FI112 and FI113 #BIReleases2013

Release Notes:

7195.300 - Rewrite BI FI reports FI112 and FI113

Admin Info

---

Purpose	Rewrite FI reports FI112 and FI113 based on BW Source.
Release No	001
Submitted	07-05-2013
Submitted by	Naga Brahmam R
Source/Destination Systems	Remote Machine to IT > BMS > Development
Release Sent To	Lori Miterko
Object(s) Created By	Naga Brahmam R
Object(s) Tested By	Naga Brahmam R

Report Name

---

FI112 - Income Statement with Last Year.

BEx Query

---

ZMP_GLPC_Q004
ZMP_GLPC_Q001

NEC Crystal Reports Standards Check

---

1. FI112 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. FI112 NEC CR checklist has been sent to NEC and also attached here for reference:
FI112 NEC CR Standard Check List.xlsx

Summary Level Check

---

Group: Emerging Markets > Sales Net

Test Conducted

SNo	Test Case	Value in CR based on BEx	Value in CR based on SAP ECC Infoset	Pass/Fail
1	Current Year Actual	4,540,856	4,540,856	Pass
2	Current Year Budget	4,396,073	4,396,073	Pass
3	Current Year Variance	144,784	144,784	Pass
4	Current Year Variance %	-3%	-3%	Pass
5	Current Year YTD Actual	16,436,570	16,436,570	Pass
6	Current Year YTD Budget	12,161,301	12,161,301	Pass
7	Current Year YTD Variance	4,275,269	4,275,269	Pass
8	Current Year YTD Variance %	-35%	-35%	Pass
9	Last Year Actual	4,540,856	4,540,856	Pass
10	Last Year Budget	4,339,499	4,339,499	Pass
11	Last Year Variance	201,357	201,357	Pass
12	Last Year Variance %	5%	5%	Pass
13	Last Year YTD Actual	16436,570	16436,570	Pass
14	Last Year YTD Budget	10,292,206	10,292,206	Pass
15	Last Year YTD Variance	6,144,364	6,144,364	Pass
16	Last Year YTD Variance %	60%	60%	Pass

Second Level Check

---

Group: Japan > Cost of goods sold > Cost of goods sold

Test Conducted

SNo	Test Case	Value in CR based on BEx	Value in CR based on SAP ECC Infoset	Pass/Fail
1	Current Year Actual	1,140,777	1,140,777	Pass
2	Current Year Budget	1,084,873	1,084,873	Pass
3	Current Year Variance	55,904	55,904	Pass
4	Current Year Variance %	5%	5%	Pass
5	Current Year YTD Actual	3,311,154	3,311,154	Pass
6	Current Year YTD Budget	3,270,547	3,270,547	Pass
7	Current Year YTD Variance	40,607	40,607	Pass
8	Current Year YTD Variance %	1%	1%	Pass
9	Last Year Actual	1,140,777	1,140,777	Pass
10	Last Year Budget	973,561	973,561	Pass
11	Last Year Variance	167,216	167,216	Pass
12	Last Year Variance %	17%	17%	Pass
13	Last Year YTD Actual	3,311,154	3,311,154	Pass
14	Last Year YTD Budget	3,164,365	3,164,365	Pass
15	Last Year YTD Variance	146,790	146,790	Pass
16	Last Year YTD Variance %	5%	5%	Pass

Third Level Check

---

Group: North America > Selling and distribution Expenses > 5th & Ocean Clothing, LLC

Test Conducted

SNo	Test Case	Value in CR based on BEx	Value in CR based on SAP ECC Infoset	Pass/Fail
1	Current Year Actual	921,695	921,695	Pass
2	Current Year Budget	1,711,809	1,711,809	Pass
3	Current Year Variance	-790,114	-790,114	Pass
4	Current Year Variance %	-9%	-9%	Pass
5	Current Year YTD Actual	6,296,662	6,296,662	Pass
6	Current Year YTD Budget	8,439,259	8,439,259	Pass
7	Current Year YTD Variance	-2,142,597	-2,142,597	Pass
8	Current Year YTD Variance %	-8%	-8%	Pass
9	Last Year Actual	921,695	921,695	Pass
10	Last Year Budget	2,073,961	2,073,961	Pass
11	Last Year Variance	-1,152,266	-1,152,266	Pass
12	Last Year Variance %	4%	4%	Pass
13	Last Year YTD Actual	6,296,662	6,296,662	Pass
14	Last Year YTD Budget	8,549,636	8,549,636	Pass
15	Last Year YTD Variance	-2,252,974	-2,252,974	Pass
16	Last Year YTD Variance %	4%	4%	Pass

Reference Document(Specification)

---

2013-05-30 - 7195.300 - Spec - Rewrite BI FI reports FI112 and FI113